|
|
| Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Nathan WAKE
Osiris Entreprises
OSE Fondation
   |
Posted - 2011.04.12 21:28:00 -
[1]
Hi Mikk36,
Looks very nice on your demo site.
But on my installed version, the little "circle timer" goes on and on and on, and I never get any data... Either that, or a direct "No matching records found" when I modify the "host" part in 'mysql://username:password@host/database'.
I've tried both on a local site (with wamp) and on a live site. Curl is enabled, configuration.php set with all what's needed (I think) and my API key is a full one with sufficient permissions.
Any ideas ? Did I miss something ?
|
Nathan WAKE
Osiris Entreprises
OSE Fondation
|
Posted - 2011.04.12 21:44:00 -
[2]
Little precision :
I tested my API Key with the https://api.eve-online.com/corp/WalletJournal.xml.aspx?userID=myuserID&apiKey=myAPiKey&characterID=mycharID URL and got the journal OK.
|
Nathan WAKE
Osiris Entreprises
OSE Fondation
|
Posted - 2011.04.13 19:13:00 -
[3]
Hello Mikk36
One thing I did not notice at first try : there was an error in the SQL syntax for creating the table "journal" (probably due to my version of MySQL : 5.0.32).
Instead of :
UNIQUE KEY `refID` (`refID`) USING BTREE,
KEY `date` (`date`) USING BTREE,
KEY `refTypeID` (`refTypeID`) USING BTREE
I had to write :
UNIQUE KEY refID USING BTREE (refID),
KEY date USING BTREE (date),
KEY refTypeID USING BTREE (refTypeID)
That created the table OK. (had to delete the 'rats' table first because of the foreign key constraint and recreate it after the 'journal' table)
Then I used the firebug extension to get the script and got the same result than on your page.
I think I'll accept your proposal and send you the address and details IG, so that you can have a look by yourself. I'm sorry for the fuss and I'm pretty sure it's nothing. But that "nothing", I can not put my hands on 
|
Nathan WAKE
Osiris Entreprises
OSE Fondation
|
Posted - 2011.04.14 19:03:00 -
[4]
Hmmm, now that's embarrassing.
Sorry Mikk36, your app works perfectly, I was just assuming that logging in was enough for updating the data.
I ran the "cron.php" and it works now.
My mistake.
Great app, and ISK donation on the way, you deserve it.
Cheers.
Nathan
|
Nathan WAKE
Caldari
Osiris Entreprises
|
Posted - 2011.06.05 09:20:00 -
[5]
Hello,
I installed it at the beginning of April, and it as been working since, pulling data with no problem at all for me.
I did not change anything in the database and it passed the different EvE updates without problem.
Nathan
|
|
|
| |
|